How to: Use the MIN function to return lowest value of a specified range.
Solution:
Select the cell where the result of the MIN function is to be displayed. Enter =MIN(<cell range>), where <cell range> is a range of cells.
NOTE: The MIN function returns the lowest value of a specified range.
1) Select the cell where the result of the MIN function is to be displayed. (The cell is highlighted.)
2) Type an equal sign and the MIN command:
=MIN()
3) Do one of the following to specify the cell range to which the MIN command applies:
a) Type the range reference within the parentheses of the MIN command.
EXAMPLE: =MIN(D5:D10)
NOTE: For multiple ranges, separate each range with a comma. No spaces should exist in the formula.
b) Select the desired range with the mouse.
NOTE: Be sure that the range is included in parentheses. For multiple ranges, separate each range with a comma.
4) Press ENTER. (Excel displays the lowest value of the specified range in the selected cell.)
